<%@ Page Language="C#" AutoEventWireup="true" CodeFile="OpenAuthorMode.aspx.cs" Inherits="OpenAuthorMode" Theme="SkinFile" ValidateRequest='false' %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Analytic Author Mode</title>
    <link rel='stylesheet' type='text/css' href="~/images/myStyle.nxa.css" />
</head>
<body class='PageBody' style="width:100%">
    <form id="ViewProjectForm" runat="server">
        <asp:Label ID='ErrorMessage' Text='' Visible="false" CssClass='ColCaption Selected'
            runat="server" />
        <asp:Button ID='btnShowEventDialog' Text='Show the Event Log...' runat="server" OnClick='DoShowEventLogDlg'
            Visible="false" />
        <asp:Panel ID='MyControls' runat='server' Width='100%'>
            <table style="width: 100%">
                <tr>
                    <td>
                        <asp:Menu ID="MenuAuthor" OnMenuItemClick='HandleMenuItemClick' runat="server" Orientation="horizontal"
                            DisappearAfter='10000' CssClass='menuAdmin'>
                            <StaticMenuStyle CssClass="staticMenuFrame" />
                            <StaticMenuItemStyle CssClass="staticMenuItems" />
                            <DynamicMenuStyle CssClass='dynamicMenuFrame' />
                            <DynamicMenuItemStyle CssClass='dynamicMenuItems' />
                            <StaticHoverStyle CssClass='staticHoverStyle' />
                            <DynamicHoverStyle CssClass='dynamicHoverStyle' />
                            <Items>
                                <asp:MenuItem Value='FileAuthor' Text='Project' >
                                    <asp:MenuItem Text='Choose Another Project...' Value='ChooseProject' ToolTip='Switch to another project' />
                                    <asp:MenuItem Text='Run External Script...' ToolTip='Run a script in another file' Value='btnMacro' />
                                    <asp:MenuItem Text='Show/Hide Script...' ToolTip='Show/Hide Script' Value='btnShowHideScript' />
                                    <asp:MenuItem ImageUrl='~/Images/MenuSeparator.png' Selectable="false"></asp:MenuItem>
                                    <asp:MenuItem Text='Export Page ...' Value='AdminSavePageExported' ToolTip='Saves the page as data' />
                                </asp:MenuItem>
                                
                                <asp:MenuItem Value='SelectAuthor' Text='Select' >
                                    <asp:MenuItem Value='btnSelect' Text='Search...' ToolTip='Select labels' />
                                    <asp:MenuItem Value='btnRange' Text='Range...' ToolTip='Select Range' />
                                    <asp:MenuItem Value='btnKeepSel' Text='Keep Selections' ToolTip='Keep selected rows (remove unselected)' />
                                    <asp:MenuItem Value='btnRemoveSel' Text='Remove Selections' ToolTip='Remove selected rows (keep unselected)' />
                                    <asp:MenuItem Value='btnClearSel' Text='Clear Selection' ToolTip='Remove the selection state on any rows or columns' />
                                    <asp:MenuItem ImageUrl='~/Images/MenuSeparator.png' Selectable="false"></asp:MenuItem>
                                    <asp:MenuItem Value='InvertRows' Text='Invert Row Selection' />
                                    <asp:MenuItem Value='InvertColumns' Text='Invert Column Selection' />
                                </asp:MenuItem>
                                
                                <asp:MenuItem Value='DataAuthor' Text='Arrange' >
                                    <asp:MenuItem Text='Create Crosstab (Pivot)...' Value='BPropertyValueToColumns'
                                        ToolTip='This is also known as a Pivot operation. Creates new page for each selected data column. The unique values from the chosen text column become the new data columns.' />
                                    <asp:MenuItem Text='Sort Rows...' ToolTip='Sorts the rows according to a column'
                                        Value='BSort' />
                                    <asp:MenuItem Text='Move/Copy Rows...' ToolTip='Moves or copies selected rows within a page or copies to another page'
                                        Value='btnMoveRow' />
                                    <asp:MenuItem Text='Move/Copy Columns...' ToolTip='Moves or copies selected columns within a page or copies to another page'
                                        Value='btnMoveColumn' />
                                    <asp:MenuItem Text='Swap Rows and Columns' ToolTip='Exchange row and column axes' Value='BSwapAxes' />
                                    <asp:MenuItem Text='Reverse Rows or Columns...' ToolTip='Reverses the order of the rows or columns'
                                        Value='BReverseOrder' />
                                </asp:MenuItem>
                                <asp:MenuItem Value='CalculateAuthor' Text='Calculate' >
                                    <asp:MenuItem Text='Combine...' ToolTip='Combine sets of rows or columns into a newly calculated one'
                                        Value='CP1' />
                                    <asp:MenuItem Text='General Math...' ToolTip='Perform simple math operations such as Divide, Multiply, Subtract, Add and Fill with Value on a set of columns'
                                        Value='CP6' />
                                    <asp:MenuItem ImageUrl='~/Images/MenuSeparator.png' Selectable="false"></asp:MenuItem>
                                    <asp:MenuItem Text='Cumulative Operations...' ToolTip='Repeat the same calculation over and over again, each one with an increasing range of rows or columns from the start to the current position'
                                        Value='CP4' />
                                    <asp:MenuItem Text='Rolling Periods...' ToolTip='Repeats your choice of (Average, Sum, Max, Min, First, Last, Median) across all the columns, each calculation spanning a sub-range of columns relative to the current one'
                                        Value='CP2' />
                                    <asp:MenuItem ImageUrl='~/Images/MenuSeparator.png' Selectable="false"></asp:MenuItem>
                                    <asp:MenuItem Text='Growth' ToolTip='Repeat Growth for every column' Value='CalculateGrowth' />
                                    <asp:MenuItem Text='Net Change' ToolTip='Repeat Difference for every column' Value='CalculateDiff' />
                                    <asp:MenuItem Text='Percentages' ToolTip='Repeat Percent for every column' Value='CalculatePercent' />
                                    <asp:MenuItem Text='Ratios' ToolTip='Repeat Ratio for every column' Value='CalculateRatio' />
                                </asp:MenuItem>
                                <asp:MenuItem Value='FilterAuthor' Text='Filter' >
                                    <asp:MenuItem Text='by Row Label...' ToolTip='Keep or remove rows when label matches certain criteria'
                                        Value='FP5' />
                                    <asp:MenuItem Text='by Text Column...' ToolTip='Keep or remove rows which have a text value that matches certain criteria'
                                        Value='FP4' />
                                    <asp:MenuItem Text='by Numeric Value...' ToolTip='Keep or remove rows which have a value in a certain column'
                                        Value='FP2' />
                                    <asp:MenuItem Text='by Comparison to Axis Value...' ToolTip='Keep or remove rows when compared to a calculated overall value'
                                        Value='FP3' />
                                    <asp:MenuItem Text='by Rows in Another Page...' ToolTip='Keep or remove rows which have a matching row in another page'
                                        Value='FP6' />
                                </asp:MenuItem>
                                <asp:MenuItem Value='CompareAuthor' Text='Compare' >
                                    <asp:MenuItem Text='To Axis...' ToolTip='Compare to an axis calculation' Value='SAB1' />
                                    <asp:MenuItem Text='To Relative Cell...' ToolTip='Compare to another cell, one that is relative to the current one'
                                        Value='SAB2' />
                                    <asp:MenuItem Text='To Specific Cell...' ToolTip='Compare to another cell, a specific cell'
                                        Value='SAB3' />
                                    <asp:MenuItem Text='To Specific Row...' ToolTip='Compare to a cell on a specific row'
                                        Value='SAB4' />
                                    <asp:MenuItem Text='To Specific Column...' ToolTip='Compare to a cell on a specific column'
                                        Value='SAB5' />
                                    <asp:MenuItem Text='Two Pages (Joiners and Leavers)...' ToolTip='Compare two pages to find the joiners, leavers, and the intersection'
                                        Value='SM' />
                                    <asp:MenuItem ImageUrl='~/Images/MenuSeparator.png' Selectable="false"></asp:MenuItem>
                                    <asp:MenuItem Text='Add Selected Row as a Baseline' ToolTip='Make selected row into a baseline to be used by test baseline operation. n.b. Only rows can be made into baselines.'
                                        Value='TP3' />
                                    <asp:MenuItem Text='Test Cells Against a Baseline...' ToolTip='Compare each cell and pass or fail it depending on being above or below a value.'
                                        Value='TP1' />
                                    <asp:MenuItem Text='Test Range Against a Baseline...' ToolTip='Compare each cell against a range of values and pass or fail it if it is outside the range.'
                                        Value='TP2' />
                                </asp:MenuItem>
                                <asp:MenuItem Value='GroupAuthor' Text='Normalize' >
                                    <asp:MenuItem Text='Fixed Buckets...' ToolTip='Show how each cell fits in a quartile or decile (or by custom number of groups)'
                                        Value='NM1' />
                                    <asp:MenuItem Text='Custom Ranges...' ToolTip='Show where each cell fits according to ranges that you enter'
                                        Value='NM6' />
                                    <asp:MenuItem Text='Rank Values...' ToolTip='Show the rank position of each cell along an axis'
                                        Value='NM2' />
                                    <asp:MenuItem Text='80-20 Assignments...' ToolTip='Show where each cell fits in bottom 20% or top 20%, or in between'
                                        Value='NM3' />
                                    <asp:MenuItem Text='Above/below threshold...' ToolTip='Show if a cell is either above or below a chosen value'
                                        Value='NM4' />
                                    <asp:MenuItem Text='Standard Deviations...' ToolTip='Show how far a cell value is from the average'
                                        Value='NM5' />
                                    <asp:MenuItem ImageUrl='~/Images/MenuSeparator.png' Selectable="false"></asp:MenuItem>
                                    <asp:MenuItem Text='Swap Cells with Columns' Value='bSwapCellsWithColumns' ToolTip='Re-groups all the data so that cells columns with the same cell value are grouped together' />
                                    <asp:MenuItem Text='Swap Cells with Row Labels' Value='bSwapCellsWithRows' ToolTip='Re-groups all the data so that cells rows with the same cell value are grouped together' />
                                    
                                </asp:MenuItem>
                                
                                <asp:MenuItem Value='DistributeAuthor' Text='Distribution'>
                                    <asp:MenuItem Text='Compare Sub-Group...' ToolTip='Compare other rows with the same value in a text column or row label'
                                        Value='CompareSimilar' />
                                    <asp:MenuItem Text='Combine Sub-Group...' ToolTip='Rows that have the same label or text column will be combined to form a new page'
                                        Value='CP8' />
                                    <asp:MenuItem ImageUrl='~/Images/MenuSeparator.png' Selectable="false"></asp:MenuItem>
                                    <asp:MenuItem Text='Combine Duplicate Rows...' ToolTip='Duplicate rows are combined to form a new page'
                                        Value='CP9' />
                                    <asp:MenuItem Text='Distribute Column Values...' ToolTip='Divide or group a range of columns so that this page matches the columns in another page'
                                        Value='CP5' />
                                    <asp:MenuItem Text='Show Count of Unique Values in a Column...' Value='script,Getcountsofvalues'
                                        ToolTip='Counts the number of times each unique value in a column occurs and displays the column values and the counts' />
                                    <asp:MenuItem Text='Create a Summary Page...' ToolTip='Choose the axis and a new page is created with a useful selection of subtotals for that axis'
                                        Value='CP7' />
                                        
                                    <asp:MenuItem ImageUrl='~/Images/MenuSeparator.png' Selectable="false"></asp:MenuItem>
                                    <asp:MenuItem Text='Distribute Row Labels to Pages' Value='BRowLabelToPages' ToolTip='Each unique row label is put onto its own page' />
                                    <asp:MenuItem Text='Distribute Text Column Values to Pages' Value='BTextColumnToPages' ToolTip='Each unique text column value is put onto its own page' />
                                    <asp:MenuItem Text='Distribute Cell Values to Pages...' Value='BColumnToPages' ToolTip='Each unique value in a column is put onto its own page. Works best if the data has been normalized!' />
                                </asp:MenuItem>

                                <asp:MenuItem Value='ViewAuthor' Text='Alert' >
                                    <asp:MenuItem Text='Alert by Comparing to Other Cell...' ToolTip='Controls the Alert highlights by comparing a cell to another cell'
                                        Value='AP2' />
                                    <asp:MenuItem Text='Alert by Comparing to Axis...' ToolTip='Controls the Alert highlights by comparing a cell to an axis summary value'
                                        Value='AP3' />
                                    <asp:MenuItem Text='Alert by Cell Value...' ToolTip='Controls the Alert highlights by directly using a cell value from a page'
                                        Value='AP4' />
                                    <asp:MenuItem Text='No Alerts...' ToolTip='Disable color highlights' Value='AP1' />
                                    <asp:MenuItem ImageUrl='~/Images/MenuSeparator.png' Selectable="false"></asp:MenuItem>
                                    <asp:MenuItem Text='Convert alert codes to data column values...' Value='btnConvertAlertsToData' ToolTip='The alert codes assigned to each cell will become the new cell value' />
                                    
                                </asp:MenuItem>
                                
                                <asp:MenuItem Value='PageAuthor' Text='Layout' >
                                    <asp:MenuItem Text='Exchange Text Column with Row Label...' Value='BSwapTextColumnAndRowLabel'
                                        ToolTip='Redefines the current crosstab that the text column becomes the new row label and the row label becomes just a text column' />

                                    <asp:MenuItem Text='Delete Text Column' ToolTip='Removes a Text Column from the page'
                                        Value='BDeleteTextColumn' />
                                        
                                    <asp:MenuItem ImageUrl='~/Images/MenuSeparator.png' Selectable="false"></asp:MenuItem>
                                    
                                    <asp:MenuItem Text='Numeric Format...' ToolTip='Assign numeric format to columns'
                                        Value='btnCellFormat' />
                                    <asp:MenuItem Text='Column Format...' ToolTip='Assign text format to columns' Value='btnColumnFormat' />
                                    <asp:MenuItem Text='Assign Text Patterns to Cells...' ToolTip='Change the cell values to context-sensitive words'
                                        Value='NM7' />
                                    
                                    <asp:MenuItem ImageUrl='~/Images/MenuSeparator.png' Selectable="false"></asp:MenuItem>
                                    
                                    <asp:MenuItem Text='Show or Hide Pages...' ToolTip='Browse the various pages and mark them as hidden or visible'
                                        Value='btnShowHidePages' />
                                    <asp:MenuItem Text='Hide All But Current Page...' ToolTip='Mark all but this one as hidden or visible'
                                        Value='btnHideAllPages' />
                                    <asp:MenuItem Text='Remove Page' Value='RemoveCurrentPage' ToolTip='Removes this page from the project (the page file itself is not deleted and can be added again later)' />
                                        
                                    <asp:MenuItem ImageUrl='~/Images/MenuSeparator.png' Selectable="false"></asp:MenuItem>

                                    <asp:MenuItem Text='Rename Rows and Columns...' ToolTip='Assign new names to rows or columns'
                                        Value='btnRename' />
                                    <asp:MenuItem Text='Rename Page Title...' ToolTip='Change the title and page description'
                                        Value='btnPageCaptionEdit' />

                                </asp:MenuItem>
                               
                            </Items>
                        </asp:Menu>
                        <asp:Panel ID='MainToolbar' CssClass='ToolBar' runat="server" Width='100%'>
                            <table width='100%'>
                                <tr>
                                    <td align="left" >
                                        <asp:DropDownList ID='ChangeSelectedPage' runat="server" AutoPostBack="true" OnSelectedIndexChanged='DoChangeSelectedPage'>
                                        </asp:DropDownList>
                                    </td>
                            </tr>
                            </table>
                        </asp:Panel>
                    </td>
                </tr>
                <tr>
                <td style="width:100%; text-align:center"><asp:TextBox CssClass='DlgTitle' ID='FilenameToSaveTo' runat="server" SkinID="wideTextBox" /></td>
                </tr>
            </table>
        </asp:Panel>
        
        <asp:Panel CssClass='L2' Visible="false" ID='CompareSimilar' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Compare Sub-group: Obtain a percentage comparison of rows that have the same text value i.e. subgroup
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton64'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose which text field to search (for unique values)</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='CompareByTextTextIndex'>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose an operation</label></td>
                                <td>
                                    
                                        <asp:DropDownList runat="server" ID='CompareByTextAggregation'>
                                        <asp:ListItem Selected="True" Value='Average'>Average</asp:ListItem>
                                        <asp:ListItem Value='Sum'>Sum</asp:ListItem>
                                        <asp:ListItem Value='Maximum'>Maximum</asp:ListItem>
                                        <asp:ListItem Value='Minimum'>Minimum</asp:ListItem>
                                        <asp:ListItem Value='First'>First</asp:ListItem>
                                        <asp:ListItem Value='Last'>Last</asp:ListItem>
                                        <asp:ListItem Value='Median'>Median</asp:ListItem>
                                    </asp:DropDownList> </td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button15' runat="server" CssClass='DlgCommandBtn' OnClick='CompareByText_Click'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                After you identify a text column, each unique value of that text column will form a subgroup. 
                                Then, the rows in that subgroup will be combined using the operation you chose. 
                                Then, each row will be shown as a percentage of that value.</label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        
        <asp:Panel CssClass='L2' Visible="false" ID='ShowAsPanel1' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Compare to an axis value</label></td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='Button1New' runat='server'
                                    ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table width='100%'>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Select the page that you want to compare to<br />
                                    </label>
                                </td>
                                <td>
                                    <asp:DropDownList runat="server" ID='AxisShowAsAxisPctPageIndex'>
                                        <asp:ListItem Value='-2'>Same Page</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Select the Axis you want to compare to</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='AxisShowAsPctAxis'>
                                        <asp:ListItem Value='Column' Selected="True">Column</asp:ListItem>
                                        <asp:ListItem Value='Row'>Row</asp:ListItem>
                                        <asp:ListItem Value='Page'>Page</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Select how to calculate the value of the axis</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='AggregationShowAsPctAxis'>
                                        <asp:ListItem Value='Average' Selected="True">Average</asp:ListItem>
                                        <asp:ListItem Value='Sum'>Sum</asp:ListItem>
                                        <asp:ListItem Value='Maximum'>Maximum</asp:ListItem>
                                        <asp:ListItem Value='Minimum'>Minimum</asp:ListItem>
                                        <asp:ListItem Value='First'>First</asp:ListItem>
                                        <asp:ListItem Value='Last'>Last</asp:ListItem>
                                        <asp:ListItem Value='Median'>Median</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose the style of the Comparison</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='AxisShowAsAxisPctComparisonType'>
                                        <asp:ListItem Value='PercentOf' Selected="True">Percent of</asp:ListItem>
                                        <asp:ListItem Value='Diff'>Difference from</asp:ListItem>
                                        <asp:ListItem Value='Ratio'>Ratio of</asp:ListItem>
                                        <asp:ListItem Value='Growth'>Growth over</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button CssClass='DlgCommandBtn' ID='Button2' runat="server" OnClick='ShowAsToAxisPct_Click'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Identify page and axis to compare to. Specify how to summarize that axis. Specify what 
                                math operation to perform when comparing.  A new page is generated with values shown 
                                as a comparison to the axis-calculation that you chose.
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='ShowAsPanel2' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Compare to relative cell, one who's position is relative to the current one</label></td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton2'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        How many rows above or below do you want to compare with</label></td>
                                <td>
                                    <asp:TextBox ID="AxisShowAsRelativeCellRowLag" Text='0' runat="server">
                                    </asp:TextBox>
                                    <label class='DlgControls'>
                                        negative number for above, positive number for below</label>
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        How many columns left or right do you want to compare with</label></td>
                                <td>
                                    <asp:TextBox ID="AxisShowAsRelativeCellColumnLag" Text='-1' runat="server"></asp:TextBox>
                                    <label class='DlgControls'>
                                        negative number to the left, positive number to the right</label>
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Select the page that you want to compare to</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='AxisShowAsRelativeCellPageIndex'>
                                        <asp:ListItem Value='-2'>Same Page</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose the style of the comparison</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='AxisShowAsRelativeCellComparisonType'>
                                        <asp:ListItem Selected="True" Value='PercentOf'>Percent of</asp:ListItem>
                                        <asp:ListItem Value='Diff'>Difference from</asp:ListItem>
                                        <asp:ListItem Value='Ratio'>Ratio of</asp:ListItem>
                                        <asp:ListItem Value='Growth'>Growth over</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button10' runat="server" CssClass='DlgCommandBtn' OnClick='ShowAsToRelativeCellPct_Click'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Identify cell to compare relative to the current one, and how to compare it.
                                If you choose a different page, then it will compare the two pages, looking for the matches with the
                                column and row labels.   It is recommended that you enter relative positions of zero and zero for this
                                kind of operation, otherwise it will compare with the matching item on the other page, shifted by
                                the position values you enter, thus producing an unpredictable value.
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='ShowAsPanel3' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Compare to another cell, a specific cell
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton3'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose a page, if the Cell is on another page</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='AxisShowAsAbsolutePositionPageIndex'>
                                        <asp:ListItem Value='-2'>Same Page</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Enter the row label or the row index preceded by #</label></td>
                                <td>
                                    <asp:TextBox ID="AxisShowAsAbsolutePositionRowIndex" runat="server" Text="" Width="58px"></asp:TextBox>
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Enter a column label or a column index preceded by #</label>
                                </td>
                                <td>
                                    <asp:TextBox ID="AxisShowAsAbsolutePositionColumnIndex" runat="server" Text="" Width="66px"></asp:TextBox>
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose the style of the comparison</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='AxisShowAsAbsolutePositionComparisonType'>
                                        <asp:ListItem Selected="True" Value='PercentOf'>Percent of</asp:ListItem>
                                        <asp:ListItem Value='Diff'>Difference from</asp:ListItem>
                                        <asp:ListItem Value='Ratio'>Ratio of</asp:ListItem>
                                        <asp:ListItem Value='Growth'>Growth over</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button CssClass='DlgCommandBtn' ID='Button19' runat="server" OnClick='btnShowAsPctAbsolutePosition_Click'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Identify a specific cell to compare to and how to compare it. This allows you to develop
                                an overall target number on one page or load it in from a separate data file, and compare 
                                all the numbers on another page to it.
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='ShowAsPanel4' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Compare to cells on a specific row
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton4'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose a page, if the row is on another page</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='AxisShowAsToARowPageIndex'>
                                        <asp:ListItem Value='-2'>Same Page</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Enter the row label or a row index preceded by a #</label></td>
                                <td>
                                    <asp:TextBox ID="AxisShowAsToARowRowIndex" runat="server" Text=""></asp:TextBox></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose the style of the comparison</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='DropAxisShowAsToARowComparisonType'>
                                        <asp:ListItem Selected="True" Value='PercentOf'>Percent of</asp:ListItem>
                                        <asp:ListItem Value='Diff'>Difference from</asp:ListItem>
                                        <asp:ListItem Value='Ratio'>Ratio of</asp:ListItem>
                                        <asp:ListItem Value='Growth'>Growth over</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button CssClass='DlgCommandBtn' ID='Button22' runat="server" OnClick='btnShowAsSpecificRow_Click'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Identify the row that has the cells you want to compare to. 
                                You can identify the row by label or index.  
                                
                                This allows you to develop
                                a row with target numbers on it or load it in from a separate data file.
                                
                                Then you can compare the numbers from the selected page page to it.
                                                                
                                The program generates a new page with new values based on
                                a comparison with a specific row but at a relatively positioned column
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='ShowAsPanel5' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Compare to a cell on a specific column
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton5'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose a page, if the column is on another page</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='AxisShowAsPctToAColumnPageIndex'>
                                        <asp:ListItem Value='-2'>Same Page</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Enter the column label or the column index preceded by #</label></td>
                                <td>
                                    <asp:TextBox ID="AxisShowAsPctToAColumnColumnIndex" runat="server" Text=""></asp:TextBox></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose the style of the comparison</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='AxisShowAsPctToAColumnComparisonType'>
                                        <asp:ListItem Selected="True" Value='PercentOf'>Percent of</asp:ListItem>
                                        <asp:ListItem Value='Diff'>Difference from</asp:ListItem>
                                        <asp:ListItem Value='Ratio'>Ratio of</asp:ListItem>
                                        <asp:ListItem Value='Growth'>Growth over</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button CssClass='DlgCommandBtn' ID='Button25' runat="server" OnClick='btnShowAsSpecificColumn_Click'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                This allows you to develop
                                a column with target numbers on it or load it in from a separate data file.
                                
                                Then you can compare the numbers from the selected page page to it.
                                
                                The program generates a new page with new values based on
                                a comparison with a specific column but at a relatively positioned row
                            </label>
                        </div>
                    </div>
                </div>
            </div>
            <table>
            </table>
        </asp:Panel>
        <asp:Panel CssClass='L2' runat="server" Visible='false' ID='NormalizePanel7'>
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Change Cell Contents to a Word
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton6'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        cell value is 1</label></td>
                                <td>
                                    <asp:TextBox  runat="server" ID='AssignColumnFormat0'></asp:TextBox></td>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        cell value is 2</label></td>
                                <td>
                                    <asp:TextBox  runat="server" ID='AssignColumnFormat1'></asp:TextBox></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        cell value is 3</label></td>
                                <td>
                                    <asp:TextBox  runat="server" ID='AssignColumnFormat2'></asp:TextBox></td>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        cell value is 4</label></td>
                                <td>
                                    <asp:TextBox  runat="server" ID='AssignColumnFormat3'></asp:TextBox></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        cell value is 5</label></td>
                                <td>
                                    <asp:TextBox  runat="server" ID='AssignColumnFormat4'></asp:TextBox></td>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        cell value is 6</label></td>
                                <td>
                                    <asp:TextBox  runat="server" ID='AssignColumnFormat5'></asp:TextBox></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        cell value is 7</label></td>
                                <td>
                                    <asp:TextBox  runat="server" ID='AssignColumnFormat6'></asp:TextBox></td>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        cell value is 8</label></td>
                                <td>
                                    <asp:TextBox  runat="server" ID='AssignColumnFormat7'></asp:TextBox></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        cell value is 9</label></td>
                                <td>
                                    <asp:TextBox  runat="server" ID='AssignColumnFormat8'></asp:TextBox></td>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        cell value is 10</label></td>
                                <td>
                                    <asp:TextBox  runat="server" ID='AssignColumnFormat9'></asp:TextBox></td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button CssClass='DlgCommandBtn' ID='Button28' runat="server" OnClick='doAssignWordsToValues'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Enter a word that you want displayed insead of a numeric value in the range of 1
                                to 10. Hint: You might use a word such as "Poor" for value 1, etc.
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='NormalizePanel6' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Group a set of ranges, according to a range of custom values
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton7'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Enter ascending values (enter comma-separated unformatted numbers)</label></td>
                                <td>
                                    <asp:TextBox runat="server" ID='NormalizeCustomRangeValues' Text='0'></asp:TextBox>
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Do you want these treated as percents?
                                    </label>
                                </td>
                                <td>
                                    <asp:CheckBox runat="server" ID='NormalizeCustomRangeAsPercent' Text='As Percent' /></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Value assignments Ascending (small values get small numbers)?</label></td>
                                <td>
                                    <asp:CheckBox runat="server" ID='NormalizeCustomRangeDescendingFlag' Text='Ascending'
                                        Checked="True" />
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        If you chose percentage calculation, which axis?</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='NormalizeCustomRangeAxis'>
                                        <asp:ListItem Value='Column' Selected="True">Down each Column</asp:ListItem>
                                        <asp:ListItem Value='Row'>Across each row</asp:ListItem>
                                        <asp:ListItem Value='Page'>Over the whole page</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button CssClass='DlgCommandBtn' ID='Button31' runat="server" OnClick='doNormalizeCustomRange'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Choose where you want the numeric breaks to occur. You can specify the cut-off points using
                                specific values (for example, to create four groups from data that ranges from 0 to 2000 in
                                increments of 500, you would enter "500,1000,1500".  This will convert all the cells 
                                to values of 1 for values from 0-500, 2 for values between 500 and 1000, 3 for values between 1000
                                and 1500, and 4 for values above 1500.
                                <br />
                                Or you can specify the ranges as percentages. If you do this, then you must enter values using
                                decimal points.  For example, .2 means 20%, .8 means 80%, etc.
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='NormalizePanel1' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Group into fixed sized numeric ranges (aka Buckets)
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton8'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                            
                            <table>
                            <tr>
                            <td><label class='DlgControls'>Choose the axis</label></td><td><asp:DropDownList runat="server" ID='NormalizeAxisFractile'>
                                <asp:ListItem Value='Column' Selected="True">Down each Column</asp:ListItem>
                                <asp:ListItem Value='Row'>Across each row</asp:ListItem>
                                <asp:ListItem Value='Page'>Over the whole page</asp:ListItem>
                            </asp:DropDownList></td>
                            </tr>
                            <tr>
                            <td><label class='DlgControls'>Enter number of buckets</label></td><td><asp:TextBox ID="NormalizeCount" runat="server" Text="4" Width="69px"></asp:TextBox> </td>
                            </tr>
                            <tr>
                            
                            <td><label class='DlgControls'>or choose a preset</label></td>
                            
                            <td>
                            
                            <asp:DropDownList runat="server" ID='PresetNtiles' AutoPostBack="true" OnSelectedIndexChanged='DoPresetNtile'>
                                <asp:ListItem Text='Pair' Value='2'></asp:ListItem>
                                <asp:ListItem Text='Quartile' Value='4'></asp:ListItem>
                                <asp:ListItem Text='Quintile' Value='5'></asp:ListItem>
                                <asp:ListItem Text='Decile' Value='10'></asp:ListItem>
                                <asp:ListItem Text='Twenty Groups' Value='20'></asp:ListItem>
                                <asp:ListItem Text='Twenty five Groups' Value='25'></asp:ListItem>
                                <asp:ListItem Text='Fifty Groups' Value='50'></asp:ListItem>
                                <asp:ListItem Text='Percentile' Value='100'></asp:ListItem>
                            </asp:DropDownList></td>
                            </tr>
                            </table>
                        <div class='DlgCommandArea'>
                            <asp:Button CssClass='DlgCommandBtn' ID='Button34' runat="server" OnClick='NTile_Click'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Choose the axis, and how many ranges you want. You can use the preset list or enter your
                                own number of groups. This evaluates the highest and lowest values along the range
                                you choose. Then it divides that numeric range into a number of equal size sub-ranges
                                (that you specify). Then it iterates through all the values, and displays a value
                                to indicate which of the ranges the original value falls into.
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='NormalizePanel2' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Show rank value of each cell
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton9'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose the axis</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='NormalizeAxisRank'>
                                        <asp:ListItem Value='Column' Selected="True">Down each column</asp:ListItem>
                                        <asp:ListItem Value='Row'>Across each row</asp:ListItem>
                                        <asp:ListItem Value='Page'>Over the whole page</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button CssClass='DlgCommandBtn' ID='Button45' runat="server" OnClick='NormalizeRank_Click'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                The rank positions will be determined for each cell in the chosen axis. 
                                This is done by internally sorting the data and then the ordinal position in the 
                                sorted list is written as the cell value.
                                <em>Tie</em> values are given the same value, but the next value following that will skip the 
                                number of tie values.
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='NormalizePanel3' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Group into three buckets: Below 20%, below 80%, and the rest
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton10'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose the axis</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='NormalizeAxis8020'>
                                        <asp:ListItem Value='Column' Selected="True">Down each column</asp:ListItem>
                                        <asp:ListItem Value='Row'>Across each row</asp:ListItem>
                                        <asp:ListItem Value='Page'>Over the whole page</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button71' runat="server" CssClass='DlgCommandBtn' OnClick='Normalize8020_Click'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Choose the axis to calculate the three groups from. Examine the numeric range between
                                the highest and lowest value and divide that range into three groups, (1) 20% or
                                below, (2) 80% or below, and (3) above 80%. The cells are re-written to indicate
                                which of three groups the cell belongs to.
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='NormalizePanel4' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Group into ranges above and below a value
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton11'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose the axis</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='AboveBelowAxis'>
                                        <asp:ListItem Value='Column' Selected="True">Down each column</asp:ListItem>
                                        <asp:ListItem Value='Row'>Across each row</asp:ListItem>
                                        <asp:ListItem Value='Page'>Over whole page</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        What do you want to be the dividing value to be?
                                    </label>
                                </td>
                                <td>
                                    <asp:DropDownList runat="server" ID='AboveBelowAggregation'>
                                        <asp:ListItem Value='Average' Selected="True">Average</asp:ListItem>
                                        <asp:ListItem Value='Median'>Median</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button82' runat="server" CssClass='DlgCommandBtn' OnClick='AboveBelow_Click'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Choose the axis to obtain the intermediary value i.e. above it, or below it. Above/Below
                                threshold categorizes your data into two buckets when the cells in the rows, columns,
                                or on the whole page are above or below the criteria you set. The evaluation criterion
                                is set by the calculations: average, first, last, median. Values that are above
                                will be assigned a 2, and values below will be assigned a 1.
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='NormalizePanel5' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Show As Number of Standard Deviations From Average
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton12'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose the axis</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='StdDevAxis'>
                                        <asp:ListItem Value='Column' Selected="True">Down each column</asp:ListItem>
                                        <asp:ListItem Value='Row'>Across each row</asp:ListItem>
                                        <asp:ListItem Value='Page'>Over whole page</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button85' runat="server" CssClass='DlgCommandBtn' OnClick='StdDev_Click'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Choose the axis to calculate the average on. Then it displays each cell in terms
                                of how many standard deviation units it is from the average.  If the value is
                                below the average, the value is shown as a negative. 
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='CalcPanel1' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Combine rows or columns into a single new row or column
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton14'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Identify which axis to perform the calculation upon</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='AxisCombine'>
                                        <asp:ListItem Selected="True" Value='Row'>Combine rows (adds new row to top)</asp:ListItem>
                                        <asp:ListItem Value='Column'>Combine columns (adds new column to left)</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose the items you want combined</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='CombineSelectionMode'>
                                        <asp:ListItem Selected="True" Value='SelectedDefaultToAll'>Selected (if nothing selected, default to all)</asp:ListItem>
                                        <asp:ListItem Value='Selected'>Selected (just selected, no default)</asp:ListItem>
                                        <asp:ListItem Value='UnSelected'>Unselected i.e., anything not selected</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose a calculation</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='AggCombine'>
                                        <asp:ListItem Selected="True" Value='Average'>Average</asp:ListItem>
                                        <asp:ListItem Value='Sum'>Sum</asp:ListItem>
                                        <asp:ListItem Value='Maximum'>Maximum</asp:ListItem>
                                        <asp:ListItem Value='Minimum'>Minimum</asp:ListItem>
                                        <asp:ListItem Value='First'>First</asp:ListItem>
                                        <asp:ListItem Value='Last'>Last</asp:ListItem>
                                        <asp:ListItem Value='Median'>Median</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        What do you want done with items that were included</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='CombineInstructionsForSelected'>
                                        <asp:ListItem Selected="True" Value='Remove'>Remove</asp:ListItem>
                                        <asp:ListItem Value='Keep'>Keep</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        What do you want done with items that were not included
                                    </label>
                                </td>
                                <td>
                                    <asp:DropDownList runat="server" ID='CombineInstructionsForUnselected'>
                                        <asp:ListItem Value='Remove'>Remove</asp:ListItem>
                                        <asp:ListItem Selected="True" Value='Keep'>Keep</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Enter the Label to be given to the new row or column
                                    </label>
                                </td>
                                <td>
                                    <asp:TextBox ID="CombineCaption" runat="server"></asp:TextBox></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                    </label>
                                </td>
                                <td>
                                    <asp:CheckBox ID='OnlyWantThisAsTrend' runat="server" Text='Convert Result into a Trend (will not be shown on the page)' />
                                </td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button88' runat="server" CssClass='DlgCommandBtn' OnClick='Combine_Click'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                This operation allows you to produce a single calculated row or column.
                                To prepare for this, might have selected some rows or columns. 
                                If you didn't, the operation usually defaults to all.
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='CalcPanel2' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Moving / Rolling Calculations
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton15'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose an operation</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='AggregationRolling'>
                                        <asp:ListItem Selected="True" Value='Average'>Average</asp:ListItem>
                                        <asp:ListItem Value='Sum'>Sum</asp:ListItem>
                                        <asp:ListItem Value='Maximum'>Maximum</asp:ListItem>
                                        <asp:ListItem Value='Minimum'>Minimum</asp:ListItem>
                                        <asp:ListItem Value='First'>First</asp:ListItem>
                                        <asp:ListItem Value='Last'>Last</asp:ListItem>
                                        <asp:ListItem Value='Median'>Median</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Enter the number of items in each calculation</label></td>
                                <td>
                                    <asp:TextBox ID="RollingPeriodCount" Text='3' runat="server" Width="58px"></asp:TextBox></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose the direction to use to obtain the moving periods?</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='RollingDirection'>
                                        <asp:ListItem Selected="True" Value='Forward'>Forward</asp:ListItem>
                                        <asp:ListItem Value='Backward'>Backward</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Starting at column (enter a zero-based number)</label></td>
                                <td>
                                    <asp:TextBox ID="RollingStartingAt" Text='0' runat="server" Width="58px"></asp:TextBox></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Enter how many columns to step each time?</label></td>
                                <td>
                                    <asp:TextBox ID="RollingStepBy" Text='1' runat="server" Width="58px"></asp:TextBox></td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button91' runat="server" CssClass='DlgCommandBtn' OnClick='RollingCalc_Click'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Repeat the same calculation over and over again, each one having a sub-range of
                                relative columns. This operation allows you to perform moving or rolling calculations.
                                For example, a popular usage will be moving-averages. This operation allows you
                                to specify forward or backward, the number of steps to take. When it gets to the
                                edge of the data, it does an estimation by repeating adjacent values so that calculations
                                are not unnecessarily skewed for lack of data.
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='CalcPanel4' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Calculate Cumulative
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton17'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose an axis</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='AxisCumulatives'>
                                        <asp:ListItem Selected="True" Value='Column'>Down each column</asp:ListItem>
                                        <asp:ListItem Value='Row'>Across each Row</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose the calculation</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='AggCumulatives'>
                                        <asp:ListItem Selected="True" Value='Sum'>Cumulative Sum</asp:ListItem>
                                        <asp:ListItem Value='Average'>Cumulative Average</asp:ListItem>
                                        <asp:ListItem Value='Maximum'>Cumulative Maximum</asp:ListItem>
                                        <asp:ListItem Value='Minimum'>Cumulative Minimum</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button97' runat="server" CssClass='DlgCommandBtn' OnClick='Cumulatives_Click'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Repeat the same calculation over and over again, each one with an increasing range
                                of rows or columns from the start to the current position. A new page will be added
                                with new values that are a result of the cumulative math operations
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='CalcPanel5' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Calculate New Column Values
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton18'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose an operation</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='DistributionFormula'>
                                        <asp:ListItem Selected="True" Value='byRatio'>Ratio</asp:ListItem>
                                        <asp:ListItem Value='byAverage'>Average</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose a page to match the number of columns to?</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='DistributionPageToImitateIndex'>
                                    </asp:DropDownList></td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button100' runat="server" CssClass='DlgCommandBtn' OnClick='Distribute_Click'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Divide the values of the columns into a larger or smaller number of values. The
                                current page will have the number of columns adjusted to match the target page.
                                If the target page has more columns, then the current page's values will be divided
                                and distributed. If the target page has fewer columns, then the current page's values
                                will be combined and re-distributed to a smaller number of columns. You can choose
                                to have the distribution calculated based on a ratio or average.
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='CalcPanel6' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Math Operations
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton24'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose a calculation</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='MathOperationAgg'>
                                        <asp:ListItem Selected="True" Value='Divide'>Divide Selected Cells by Value</asp:ListItem>
                                        <asp:ListItem Value='Multiply'>Multiply Selected Cells With Value</asp:ListItem>
                                        <asp:ListItem Value='Subtract'>Subtract Value From Selected</asp:ListItem>
                                        <asp:ListItem Value='Add'>Add Value To Selected</asp:ListItem>
                                        <asp:ListItem Value='FillEmptyWithValue'>Fill Missing values with a value</asp:ListItem>
                                        <asp:ListItem Value='FillEmptyWithLag'>Fill Empty values by repeating values from cell + N (to the right) or - N (to the left) </asp:ListItem>
                                        <asp:ListItem Value='FillWithValue'>Change selected columns to contain all one value</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Enter value to use (for the math operation)?</label></td>
                                <td>
                                    <asp:TextBox ID="MathOperationParam1" Text='100' runat="server" Width="58px"></asp:TextBox></td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button103' runat="server" CssClass='DlgCommandBtn' OnClick='MathOperation_Click'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Perform simple math operations on a set of columns. Works only on cells in selected rows
                                and selected columns unless nothing is selected, in which case it operates on all rows
                                and columns. The exception is Fill Missing Values: This operation replaces all missing
                                values without using selection state.
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='CalcPanel7' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                   Create Summary Page
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton25'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Select an axis
                                    </label>
                                </td>
                                <td>
                                    <asp:DropDownList runat="server" ID='AutoAggregateAxis'>
                                        <asp:ListItem Value='Column' Selected="True">Column</asp:ListItem>
                                        <asp:ListItem Value='Row'>Row</asp:ListItem>
                                        <asp:ListItem Value='Page'>Page</asp:ListItem>
                                    </asp:DropDownList>
                                </td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button106' runat="server" CssClass='DlgCommandBtn' OnClick='doAddAutoAggregate'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Choose the axis and a new page will be created with an interesting and useful 
                                selection of subtotals for that axis.
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='FilterPanel2' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Filter by Numeric Value
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton26'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                                    <label class='DlgControls'>
                                        Choose a numeric column to test</label>
                                    <asp:DropDownList runat="server" ID='FilterValueColumns'>
                                    </asp:DropDownList>
                                    
                                    <label class='DlgControls'>
                                    </label>
                                
                                   <asp:DropDownList runat="server" ID='FilterCompareOperator'>
                                        <asp:ListItem Value='LessThan' Selected="True">Less Than</asp:ListItem>
                                        <asp:ListItem Value='LessThanOrEqualTo'>Less Than or Equal To</asp:ListItem>
                                        <asp:ListItem Value='Equal'>Equal To</asp:ListItem>
                                        <asp:ListItem Value='GreaterThan'>Greater Than</asp:ListItem>
                                        <asp:ListItem Value='GreaterThanOrEqualTo'>Greater Than or Equal To</asp:ListItem>
                                    </asp:DropDownList>
                                
                                    <label class='DlgControls'>
                                    </label>
                                
                                <asp:TextBox ID="FilterValueToCompareTo" Text='0' runat="server" Width="58px"></asp:TextBox>
                                
                                <asp:DropDownList runat="server" ID='FilterByValueCommand'>
                                        <asp:ListItem Selected="True" Value='RemoveByVal'>Remove rows</asp:ListItem>
                                        <asp:ListItem Value='KeepByVal'>Keep rows</asp:ListItem>
                                        <asp:ListItem Value='JustSelect'>Select rows</asp:ListItem>
                                        <asp:ListItem Value='Flag'>Add a column flag</asp:ListItem>
                                    </asp:DropDownList>
                                
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button109' runat="server" CssClass='DlgCommandBtn' OnClick='FilterByValue_Click'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Keep or remove rows which have a value in a certain column. Reduce the number of
                                rows of data by examining values in a column and remove, keep, flag or select the
                                rows that meet the criteria.
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='FilterPanel3' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Filter by Comparison to Axis Value
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton27'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose a value to test</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='AxisFilterValueColumns'>
                                    </asp:DropDownList>
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose how the value is to be compared
                                    </label>
                                </td>
                                <td>
                                    <asp:DropDownList runat="server" ID='AxisFilterCompareOperator'>
                                        <asp:ListItem Value='LessThan' Selected="True">Less Than</asp:ListItem>
                                        <asp:ListItem Value='LessThanOrEqualTo'>Less Than or Equal To</asp:ListItem>
                                        <asp:ListItem Value='Equal'>Equal To</asp:ListItem>
                                        <asp:ListItem Value='GreaterThan'>Greater Than</asp:ListItem>
                                        <asp:ListItem Value='GreaterThanOrEqualTo'>Greater Than or Equal To</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose how you want the axis value to be calculated
                                    </label>
                                </td>
                                <td>
                                    <asp:DropDownList runat="server" ID='AxisFilterAggregationToCompareTo'>
                                        <asp:ListItem Selected="True" Value='Average'>Average</asp:ListItem>
                                        <asp:ListItem Value='Sum'>Sum</asp:ListItem>
                                        <asp:ListItem Value='Maximum'>Maximum</asp:ListItem>
                                        <asp:ListItem Value='Minimum'>Minimum</asp:ListItem>
                                        <asp:ListItem Value='First'>First</asp:ListItem>
                                        <asp:ListItem Value='Last'>Last</asp:ListItem>
                                        <asp:ListItem Value='Median'>Median</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Optional: Enter value to be added to the calculated axis value
                                        <br />
                                        <em>hint: enter a negative number to subtract from it</em>
                                    </label>
                                </td>
                                <td>
                                    <asp:TextBox ID="AxisFilterValueToCompareTo" Text='0' runat="server" ></asp:TextBox><br />
                                    <asp:CheckBox ID='AxisFilterAsPercent' Checked="false" runat="server" 
                                            Text='As Percent?' /></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        What would you like done with rows that meet the criteria?
                                    </label>
                                </td>
                                <td>
                                    <asp:DropDownList runat="server" ID='AxisFilterCommand'>
                                        <asp:ListItem Selected="True" Value='RemoveByVal'>Remove</asp:ListItem>
                                        <asp:ListItem Value='KeepByVal'>Keep</asp:ListItem>
                                        <asp:ListItem Value='JustSelect'>Select</asp:ListItem>
                                        <asp:ListItem Value='Flag'>Flag</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button112' runat="server" CssClass='DlgCommandBtn' OnClick='FilterByAxisValue_Click'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Compare each rows against the calculated value.  If it matches a certain criteria then 
                                you can keep, remove, select, or flag the row (with a new data column). 
                                If you entered an optional value that is a percent, you must enter it as a decimal value; e.g. 10% is .1
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='FilterPanel4' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Filter by Text Values
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton28'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Enter the text to compare</label></td>
                                <td>
                                    <asp:TextBox ID='FilterByCaptionFromAPropertyValue' runat="server"></asp:TextBox></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose a method of comparison
                                    </label>
                                </td>
                                <td>
                                    <asp:DropDownList ID='FilterByPropertyValueMatchType' runat="server">
                                        <asp:ListItem Selected="true" Value='ExactMatch'>Exact Match</asp:ListItem>
                                        <asp:ListItem Value='StartsWith'>Starts With</asp:ListItem>
                                        <asp:ListItem Value='EndsWith'>Ends With</asp:ListItem>
                                        <asp:ListItem Value='Contains'>Contains</asp:ListItem>
                                    </asp:DropDownList>
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose a text column to compare against</label></td>
                                <td>
                                    <asp:DropDownList ID='FilterByCaptionFromAPropertyIndex' runat="server">
                                    </asp:DropDownList>
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        What would you like done with rows that match?</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='FilterByCaptionFromAPropertyValueAction'>
                                        <asp:ListItem Selected="True" Value='RemoveBySel'>Remove</asp:ListItem>
                                        <asp:ListItem Value='KeepBySel'>Keep</asp:ListItem>
                                        <asp:ListItem Value='JustSelect'>Select</asp:ListItem>
                                        <asp:ListItem Value='Flag'>Flag</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button115' runat="server" CssClass='DlgCommandBtn' OnClick='FilterByPropertyValue_Click'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Keep or remove rows which have a text value that matches certain criteria . Compares
                                each row to the value you specify and discards unwanted rows
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='FilterPanel5' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Filter by Row Label
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton29'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Enter the text to compare</label></td>
                                <td>
                                    <asp:TextBox ID='FilterByCaptionFromThisPageCaption' runat="server"></asp:TextBox>
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose a method of comparison
                                    </label>
                                </td>
                                <td>
                                    <asp:DropDownList ID='FilterByCaptionMatchType' runat="server">
                                        <asp:ListItem Selected="true" Value='ExactMatch'>Exact Match</asp:ListItem>
                                        <asp:ListItem Value='StartsWith'>Starts With</asp:ListItem>
                                        <asp:ListItem Value='EndsWith'>Ends With</asp:ListItem>
                                        <asp:ListItem Value='Contains'>Contains</asp:ListItem>
                                    </asp:DropDownList>
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        What would you like done with rows that match?
                                    </label>
                                </td>
                                <td>
                                    <asp:DropDownList runat="server" ID='FilterByCaptionFromThisPageAction'>
                                        <asp:ListItem Selected="True" Value='RemoveBySel'>Remove</asp:ListItem>
                                        <asp:ListItem Value='KeepBySel'>Keep</asp:ListItem>
                                        <asp:ListItem Value='JustSelect'>Select</asp:ListItem>
                                        <asp:ListItem Value='Flag'>Flag</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button118' runat="server" CssClass='DlgCommandBtn' OnClick='FilterByCaptionValue_Click'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Keep or remove rows where the label matches the criteria</label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='FilterPanel6' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Filter by Rows in Another Page
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton30'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose a Page which contains row labels</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='FilterByCaptionFromAnotherPagePageIndex'>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        What would you like done with row labels that are on both pages?
                                    </label>
                                </td>
                                <td>
                                    <asp:DropDownList runat="server" ID='FilterByCaptionFromAnotherPageAction'>
                                        <asp:ListItem Selected="True" Value='RemoveBySel'>Remove</asp:ListItem>
                                        <asp:ListItem Value='KeepBySel'>Keep</asp:ListItem>
                                        <asp:ListItem Value='JustSelect'>Select</asp:ListItem>
                                        <asp:ListItem Value='Flag'>Flag</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button121' runat="server" CssClass='DlgCommandBtn' OnClick='FilterByCaptionFromAnotherPage_Click'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Compare the rows in the currently selected page with the rows in the page that you identify.
                                If a match is found, then you have the choice to keep or remove that row.
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='FilterPanel1' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Filter by Selection
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton31'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button CssClass='DlgCommandBtnDefault' ID='RemoveSelected' ToolTip='Keeps Unselected'
                                runat="server" OnClick='RemoveSelected_Click' Text='Remove Selected' CommandArgument='ClosePanels' />
                            <asp:Button ID='RemoveUnselected' runat="server" CssClass='DlgCommandBtn' OnClick="RemoveUnselected_Click"
                                Text='Keep Selected' ToolTip='Removes Unselected' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Keep or remove selected rows</label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='SetMathPanel' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Joiners and Leavers
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton16'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose the First Page</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='SetMathPage1'>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose the Second Page</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='SetMathPage2'>
                                    </asp:DropDownList></td>
                            </tr>
                            
                            <tr>
                            <td class='DlgControlsArea'><label class='DlgControls'>Leavers are rows that were in the first page but not the second</label></td>
                            <td>
                            <asp:Button ID='FindLeavers' runat="server" CssClass='DlgCommandBtn' OnClick="JoinersAndLeavers_Click"
                                Text='Find Leavers' ToolTip='Find Leavers' CommandArgument='leave;ClosePanels' />
                                </td>
                            </tr>
                            
                            <tr>
                            <td class='DlgControlsArea'><label class='DlgControls'>Joiners are rows that were NOT in the first page but are present in the second</label></td>
                            <td><asp:Button ID='FindJoiners' runat="server" CssClass='DlgCommandBtn' OnClick="JoinersAndLeavers_Click"
                                Text='Find Joiners' ToolTip='Find Joiners' CommandArgument='join;ClosePanels' /></td>
                            </tr>

                            <tr>
                            <td class='DlgControlsArea'><label class='DlgControls'>Both means that rows had to be present in both</label></td>
                            <td><asp:Button ID='FindInBoth' runat="server" CssClass='DlgCommandBtn' OnClick="JoinersAndLeavers_Click"
                                Text='Show Rows In Both' ToolTip='Find Intersection' CommandArgument='both;ClosePanels' /></td>
                            </tr>

                        </table>
                            
                        
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Compare two pages to determine what they have in common and not in common.
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='TestPanel3' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Add Selected Row As Baseline
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton32'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button127' runat="server" CssClass='DlgCommandBtn' OnClick='doAddSelectedRowAsTrend'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Establish the selected row as a baseline. By indicating that row is a baseline, it becomes
                                available for Test operations
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='TestPanel1' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Part 1: Test rows against a Baseline, cell by cell
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton33'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        If a cell is
                                    </label>
                                    <asp:DropDownList  runat="server" ID='BaselineComparisonOperator'>
                                        <asp:ListItem Value='LessThan' Selected="True">Less Than</asp:ListItem>
                                        <asp:ListItem Value='LessThanOrEqualTo'>Less Than or Equal To</asp:ListItem>
                                        <asp:ListItem Value='Equal'>Equal To</asp:ListItem>
                                        <asp:ListItem Value='GreaterThan'>Greater Than</asp:ListItem>
                                        <asp:ListItem Value='GreaterThanOrEqualTo'>Greater Than or Equal To</asp:ListItem>
                                    </asp:DropDownList>
                                    <asp:DropDownList  runat="server" ID='BaselineId'>
                                    </asp:DropDownList>
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>then it will be</label>
                                    <asp:TextBox ID="BaselineTrueColumnCaption" runat="server" Text="True"></asp:TextBox>
                                    
                                    <label class='DlgControls'>Otherwise, it will be </label>
                                    <asp:TextBox ID="BaselineFalseColumnCaption" runat="server" Text="False"></asp:TextBox>
                                </td>
                            </tr>
                        </table>
                        <label class='DlgTitle'>
                            Part 2: Count the True cells. Add a new column, and mark the Row True if the following condition is True.</label>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>When Count of True is </label>
                                    <asp:DropDownList  runat="server" ID='BaselineThresholdComparisonOperator'>
                                        <asp:ListItem Value='LessThan'>Less Than</asp:ListItem>
                                        <asp:ListItem Value='LessThanOrEqualTo'>Less Than or Equal To</asp:ListItem>
                                        <asp:ListItem Value='Equal'>Equal To</asp:ListItem>
                                        <asp:ListItem Selected="True" Value='GreaterThan'>Greater Than</asp:ListItem>
                                        <asp:ListItem Value='GreaterThanOrEqualTo'>Greater Than or Equal To</asp:ListItem>
                                    </asp:DropDownList>
                                    <asp:TextBox  ID="BaselineThresholdCount" runat="server" Text="0"
                                        Width="58px"></asp:TextBox>
                                    <asp:TextBox  ID="BaselineOverallColumnCaption" runat="server"
                                        Text="Passed Baseline"></asp:TextBox>
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    <asp:CheckBox ID='BaselineConsecutive' runat="server" Text='Stop when threshold met in consecutive cells' />
                                    <asp:CheckBox ID='BaselineStopAtThresholdCount' runat="server" Text='Stop when threshold met' />
                                 </td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID="Button36" runat="server" Text='Autopopulate' OnClick='DoAutopopulate' />
                            <asp:Button ID='ButtonXyz' runat="server" CssClass='DlgCommandBtn' OnClick='TestByComparison_Click'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Compare each cell in a row and pass or fail it depending on being above or below
                                a value. Count of tests equaling false. Tests each cell value against a baseline value
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='TestPanel2' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Part 1: Test rows against a baseline row <em>using a plus/minus range</em>
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton34'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        If a cell is</label>
                                    <asp:DropDownList  runat="server" ID='BaselineComparisonOperatorR'>
                                        <asp:ListItem Value='WithinRange' Selected="True">Within</asp:ListItem>
                                        <asp:ListItem Value='OutsideOfRange'>Outside of</asp:ListItem>
                                    </asp:DropDownList>
                                    <asp:TextBox  ID="BaselinePercentBaselineValue" runat="server"
                                        Text="15"></asp:TextBox>
                                    <label class='DlgControls'>
                                        % of the corresponding value in
                                    </label>
                                    <asp:DropDownList  runat="server" ID='BaselineIdR'>
                                    </asp:DropDownList>
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        then it will be
                                    </label>
                                    <asp:TextBox  ID="BaselineFalseColumnCaptionR" runat="server"
                                        Text="True"></asp:TextBox>
                                    <label class='DlgControls'>
                                        Otherwise, it will be
                                    </label>
                                    <asp:TextBox  ID="BaselineTrueColumnCaptionR" runat="server"
                                        Text="False"></asp:TextBox>
                               </td>
                            </tr>
                        </table>
                        <label class='DlgTitle'>
                            Part 2: Count the True cells. Add  new column, and mark the Row True if the following condition is True.</label>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>When Count of True is </label>
                                    <asp:DropDownList  runat="server" ID='BaselineThresholdComparisonOperatorR'>
                                        <asp:ListItem Value='LessThan'>Less Than</asp:ListItem>
                                        <asp:ListItem Value='LessThanOrEqualTo'>Less Than or Equal To</asp:ListItem>
                                        <asp:ListItem Value='Equal'>Equal To</asp:ListItem>
                                        <asp:ListItem Selected="True" Value='GreaterThan'>Greater Than</asp:ListItem>
                                        <asp:ListItem Value='GreaterThanOrEqualTo'>Greater Than or Equal To</asp:ListItem>
                                    </asp:DropDownList>
                                    <asp:TextBox  ID="BaselineThresholdCountR" runat="server" Text="0"></asp:TextBox>
                                    
                                    <asp:TextBox  ID="BaselineOverallColumnCaptionR" runat="server"
                                        Text="Passed Baseline"></asp:TextBox>
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <asp:CheckBox ID='BaselineConsecutiveR' runat="server" Text='Must be consecutive' />
                                    <asp:CheckBox ID='BaselineStopAtThresholdCountR' runat="server" Text="Stop at threshold" />
                                </td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID="Button35" runat="server" Text='Autopopulate' OnClick='DoAutopopulate' />
                            <asp:Button ID='Button133' runat="server" CssClass='DlgCommandBtn' OnClick='TestByComparisonR_Click'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Compare each cell in a row against a range of values and pass or fail it if it is
                                outside the range.</label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel Visible="false" CssClass='L2' runat="server" ID='ShowHidePagesDlg'>
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Show or Hide Pages
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton35'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Identify a Page and choose an action
                                    </label>
                                </td>
                                <td>
                                    <asp:DropDownList runat="server" ID='AllPages'>
                                    </asp:DropDownList>
                                    <br />
                                    <asp:Button ID='changePage' OnClick='DoChangePage' runat="server" Text='Switch' ToolTip='Display the selected page' />
                                    <asp:Button ID="ImageButton13" OnClick="DoRemovePage" Text='Remove' runat="server" />
                                    <asp:Button ID='btnHideShowPage' OnClick='DoHidePage' Text='Show/Hide' runat="server" />
                                    <br />
                                </td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Show or Hide Pages</label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel Visible="false" CssClass='L2' runat="server" ID='ShowEventLogDlg'>
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Show the Session Event Log
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton20'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        
                        <div>
                            <asp:Button ID='BtnClearEventLog' OnClick='DoClearEventLog' runat="server" Text='Clear Session Log'
                                ToolTip='Clear the event log of this Session' />
                            <asp:Button ID='BtnChooseOnEvent' OnClick='SwitchToChooseProject' runat="server"
                                Text='Choose Another Project' ToolTip='Switch to another project' /><br />
                        </div>
                        <div style="width: 100%; height: 25%" runat="server" id='EventLogZone' enableviewstate="false"  />
                        <br />
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                As project or scripts execute step by step, this dialog box allows you to see what
                                occurred. You can also use this to to clear the event log.  <br />
                                It is important to note that this is a power user dialog box and the workflow is optimized 
                                for that kind of user. This means that certain safeguards are not present. 
                                If you switch to Choose Another Project, you will not be prompted to save your work in 
                                progress (using the Run/Save button) and you could lose your un-saved worked. 
                                Changes are saved as a text file in your projects directory. <b>For the ability to write
                                the file to disk, you will need to ensure that the NETWORK SERVICE has write access to 
                                the Project directory.</b>  
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel Visible="false" CssClass='L2' ID="PanelRangeSelect" runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>Select Range of Rows or Columns</label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton19'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                    <asp:DropDownList runat="server" ID='SelectRangeAxis'>
                        <asp:ListItem Value='Row' Selected="True">Select Rows</asp:ListItem>
                        <asp:ListItem Value='Column'>Select Columns</asp:ListItem>
                    </asp:DropDownList>
                    <br />
                    <label class='DlgControls'>Starting at</label>
                    <br />
                    <asp:TextBox ID='SelectRangeStart' runat="server" Text='0'></asp:TextBox>
                    <br />
                    <label class='DlgControls'>for a Count of</label>
                    <br />
                    <asp:TextBox ID='SelectRangeCount' runat="server" Text='10'></asp:TextBox>
                    
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button14' runat="server" CssClass='DlgCommandBtn' OnClick='SelectRange'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                            This operation allows you to specify a starting position and a count.
                            It then looks at the data on the axis you chose, and selects that many rows.
                            Instead of specifying a number, you can put the word First or Last. 
                            <b>If you specify Last, then it automatically counts backwards. This makes it very easy to
                            select "the last 10 rows" or "the last 12 months of data" without having to know how many
                            columns there are or what their names are.</b>
                            If you specify Next or Previous, then it bases the position from your most recent selection
                            on that axis
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        
        <asp:Panel Visible="false" CssClass='L2' runat="server" ID='SelectDlg'>
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Searches for Text</label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton36'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td>
                                    <label class='DlgControls'>Look in column</label>
                                    <asp:DropDownList  ID='FindTextTextColumnNames' runat="server">
                                    </asp:DropDownList>
                                    <label class='DlgControls'>for</label>
                                    
                                    <asp:DropDownList  ID='FindTextTextColumnOperator' runat="server">
                                        <asp:ListItem Value='ExactMatch'></asp:ListItem>
                                        <asp:ListItem Value='StartsWith'></asp:ListItem>
                                        <asp:ListItem Value='EndsWith'></asp:ListItem>
                                        <asp:ListItem Value='Contains'></asp:ListItem>
                                    </asp:DropDownList>
                                    <asp:TextBox ID="FindText" runat="server"></asp:TextBox>
                                    <asp:Button ID='btnSearch' OnClick='DoRowFind2' runat="server" ToolTip='Search' Text='Search' />
                                </td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                            This allows you to look in the row label column or any text column. 
                            When it finds a match, it selects the row and continues the search.
                            You can perform this operation repeatedly to get a larger set.
                            After you have a range selected, useful things you can do include KeepSelected, RemoveSelected,
                            or Combine.  Many nextanalytics operations use the selection state to know what to operate on.
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel Visible="false" CssClass='L2' ID="PanelSort" runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Sort Rows
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton37'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                                    
                        <label class='DlgControls'>
                            Sort the rows by examining the values in
                        </label>
                        
                        <asp:DropDownList runat="server" ID='SortColumns'>
                        </asp:DropDownList>
                        <asp:DropDownList ID='SortOrder' runat="server">
                            <asp:ListItem Value='True' Selected="true">Descending</asp:ListItem>
                            <asp:ListItem Value='False'>Ascending</asp:ListItem>
                        </asp:DropDownList>
                                    
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button136' runat="server" CssClass='DlgCommandBtn' OnClick='DoSort'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Re-arrange the order of the rows according to a order of values in a specified column.
                                If you are doing this in script, you can also use the word First or Last instead of a 
                                numeric column name.
                                </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel Visible="false" CssClass='L2' ID="PanelReverseOrder" runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Reverse the order of the rows or columns
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton38'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                                <label class='DlgTitle'>
                                    Reverse
                                </label>
                                
                                    <asp:DropDownList runat="server" ID='ReverseAxis'>
                                        <asp:ListItem Value='Column' Selected="True">the columns</asp:ListItem>
                                        <asp:ListItem Value='Row'>the rows</asp:ListItem>
                                    </asp:DropDownList>

                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button139' runat="server" CssClass='DlgCommandBtn' OnClick='doReverseAxis'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Re-arrange the order of the rows or columns</label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel Visible="false" CssClass='L2' ID="PanelMoveRow" runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Move or copy rows
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton39'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                    </label>
                                </td>
                                <td>
                                    <asp:DropDownList runat="server" ID='MoveRowsAction' AutoPostBack="true" OnSelectedIndexChanged='DoCheckMoveRows'>
                                        <asp:ListItem Value='Move' Selected="True">Move Selected Rows</asp:ListItem>
                                        <asp:ListItem Value='Copy'>Copy Selected Rows</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        To
                                    </label>
                                </td>
                                <td>
                                    <asp:DropDownList runat="server" ID='MoveRowsDestinationInstructions' AutoPostBack="true"
                                        OnSelectedIndexChanged='DoCheckMoveRows'>
                                        <asp:ListItem Value='First' Selected="True">First</asp:ListItem>
                                        <asp:ListItem Value='Last'>Last</asp:ListItem>
                                        <asp:ListItem Value='InFrontOf'>In front of</asp:ListItem>
                                    </asp:DropDownList>
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls' id='RowIndexText' runat="server" visible="false">
                                        Row Index
                                    </label>
                                </td>
                                <td>
                                    <asp:TextBox ID='MoveRowsPosition' runat="server" Text="0"
                                        Visible="false"></asp:TextBox>
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls' runat="server" id='MoveRowsPagesText' visible="false">
                                        To Page</label></td>
                                <td>
                                    <asp:DropDownList ID='MoveRowsPages' runat="server" Visible="false">
                                    </asp:DropDownList><br />
                                </td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button142' runat="server" CssClass='DlgCommandBtn' OnClick='doMoveRows'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Move or copy rows to a new location in the same page or to a new page. Move only
                                applies if you are moving in the same page.</label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel Visible="false" CssClass='L2' ID="PanelMoveColumn" runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Move or copy columns
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton40'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                    </label>
                                </td>
                                <td>
                                    <asp:DropDownList runat="server" ID='MoveColumnsAction' AutoPostBack="true" OnSelectedIndexChanged='DoCheckMoveColumns'>
                                        <asp:ListItem Value='Move' Selected="True">Move Selected Columns</asp:ListItem>
                                        <asp:ListItem Value='Copy'>Copy Selected Columns</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        To
                                    </label>
                                </td>
                                <td>
                                    <asp:DropDownList runat="server" ID='MoveColumnsDestinationInstructions' AutoPostBack="true"
                                        OnSelectedIndexChanged='DoCheckMoveColumns'>
                                        <asp:ListItem Value='First' Selected="True">First</asp:ListItem>
                                        <asp:ListItem Value='Last'>Last</asp:ListItem>
                                        <asp:ListItem Value='InFrontOf'>In front of</asp:ListItem>
                                    </asp:DropDownList><br />
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls' id='ColumnIndexText' runat="server" visible="false">
                                        Column Index
                                    </label>
                                </td>
                                <td>
                                    <asp:TextBox ID='MoveColumnsPosition' runat="server" Text="0" Visible="false"></asp:TextBox>
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls' id='MoveColumnsPagesText' runat="server" visible="false">
                                        To Page</label></td>
                                <td>
                                    <asp:DropDownList ID='MoveColumnsPages' runat="server" Visible="false">
                                    </asp:DropDownList><br />
                                </td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button145' runat="server" CssClass='DlgCommandBtn' OnClick='doMoveColumns'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Move or copy columns to a new location in the same page or to a new page. Move only
                                applies if you are moving in the same page.</label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel Visible="false" CssClass='L2' ID="PanelColumnToPages" runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Move Column To Pages
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton41'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose a Column to divide into pages</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='MoveColumnToPagesColumns'>
                                    </asp:DropDownList>
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Enter a prefix do you want to give to the newly created page names
                                    </label>
                                </td>
                                <td>
                                    <asp:TextBox ID='MoveColumnToPagesPagePrefix' runat="server"></asp:TextBox>
                                </td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button148' runat="server" CssClass='DlgCommandBtn' OnClick='doMoveColumnToPages'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Separate rows into separate pages. Each unique value in the specified numeric column will get is 
                                own page.  For this reason, it's usually recommended to precede this operation with one of the 
                                normalization functions.</label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel Visible="false" CssClass='L2' ID='PanelPropertyValueToColumns' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Create Crosstab (Pivot)
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton42'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose a Text Column</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='SwapTextColumnWithColumnPropertyIndex'>
                                    </asp:DropDownList></td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button151' runat="server" CssClass='DlgCommandBtn' OnClick='doSwapTextColumnWithColumn'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                This creates a crosstab.   It can be used on transaction files or another crosstab.
                                The unique values from the chosen text column become the new data columns.
                                If there is more than one numeric column in the page, then a new crosstab is created for each 
                                one that is selected.
                            </label>
                        </div>
                    </div>
                </div>
            </div>
            <table>
            </table>
        </asp:Panel>
        <asp:Panel Visible="false" CssClass='L2' ID='PanelTextColumnToPages' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Text Column to Pages
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton23'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose a Property</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='SwapTextColumnWithColumnPropertyIndex2'>
                                    </asp:DropDownList></td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button16' runat="server" CssClass='DlgCommandBtn' OnClick='doMoveUniqueTextColumnToPages'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Move rows with the same text column value to their own pages. This is a grouping
                                operation. All rows with the same text column value will be moved to a common page.
                            </label>
                        </div>
                    </div>
                </div>
            </div>
            <table>
            </table>
        </asp:Panel>
        <asp:Panel Visible="false" CssClass='L2' ID='PanelSwapTextColumnAndRowLabel' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Exchange Text Column with Row Label
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton59'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose a Property</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='SwapTextColumnRowLabelPropertyIndex'>
                                    </asp:DropDownList></td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button13' runat="server" CssClass='DlgCommandBtn' OnClick='doSwapTextColumnWithRowLabel'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Choose a text column that will become the new row label. Redefines how the crosstab
                                is organized. The text column that you choose becomes the main label for the row.
                            </label>
                        </div>
                    </div>
                </div>
            </div>
            <table>
            </table>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='CalcPanel8' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Combine Sub-Group: Aggregate Rows if they have the same or similar text values
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton21'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose which text field to search (for unique values)</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='CombineByTextTextIndex'>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose an operation</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='CombineByTextAggregation'>
                                        <asp:ListItem Selected="True" Value='Average'>Average</asp:ListItem>
                                        <asp:ListItem Value='Sum'>Sum</asp:ListItem>
                                        <asp:ListItem Value='Maximum'>Maximum</asp:ListItem>
                                        <asp:ListItem Value='Minimum'>Minimum</asp:ListItem>
                                        <asp:ListItem Value='First'>First</asp:ListItem>
                                        <asp:ListItem Value='Last'>Last</asp:ListItem>
                                        <asp:ListItem Value='Median'>Median</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button3' runat="server" CssClass='DlgCommandBtn' OnClick='AggregationByText_Click'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                After you identify a text column, each unique value of that text column will form a subgroup.  
                                Then, the rows in that subgroup will be combined using the operation you chose. 
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='CalcPanel9' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Combine Duplicate Rows
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton22'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose an operation</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='CombineDuplicatesAggregation'>
                                        <asp:ListItem Selected="True" Value='Average'>Average</asp:ListItem>
                                        <asp:ListItem Value='Sum'>Sum</asp:ListItem>
                                        <asp:ListItem Value='Maximum'>Maximum</asp:ListItem>
                                        <asp:ListItem Value='Minimum'>Minimum</asp:ListItem>
                                        <asp:ListItem Value='First'>First</asp:ListItem>
                                        <asp:ListItem Value='Last'>Last</asp:ListItem>
                                        <asp:ListItem Value='Median'>Median</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button12' runat="server" CssClass='DlgCommandBtn' OnClick='CombineDuplicates_Click'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Identical rows will be combined using an operation of your choosing.</label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel Visible="false" CssClass='L2' ID='PanelSwapCellsWithColumns' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Exchange Cell Values and Column Labels
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton43'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Exchange Values with Column Labels</label></td>
                                <td>
                                    <asp:Button CssClass='DlgCommandBtn' runat="server" Text='Values and Column Labels'
                                        ID='Button42' OnClick="SwapValuesWithColumnLabels_Click" CommandArgument='ClosePanels' />
                                </td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Exchange cell values and column labels. Labels on the column axis will have the
                                values will be grouped together. This provides a handy list which can be cut/pasted
                                into other applications.
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel Visible="false" CssClass='L2' ID='PanelSwapCellsWithRows' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Exchange Row Labels with Cell Values
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton44'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Exchange Values with Row Labels</label></td>
                                <td>
                                    <asp:Button CssClass='DlgCommandBtn' runat="server" Text='Values and Row Labels'
                                        ID='SwapValuesWithRowLabels' OnClick="SwapValuesWithRowLabels_Click" CommandArgument='ClosePanels' />
                                </td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Exchange cell values and row labels. Labels on the row axis will have the values
                                will be grouped together. This provides a handy list which can be cut/pasted into
                                other applications. The final choice is a convenient way to re-orient the table
                                on its side.
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel Visible="false" CssClass='L2' ID='PanelSwapAxes' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Exchange Rows and Columns
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton45'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                    </label>
                                </td>
                                <td>
                                    <asp:Button CssClass='DlgCommandBtn' runat="server" Text='Exchange Rows and Columns'
                                        ID='Button9' OnClick="SwapAxes_Click" CommandArgument='ClosePanels' />
                                </td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Put the Row Labels as Column Labels, and vice-versa. This a convenient way to re-orient
                                the table on its side.
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='AlertPanel1' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Disables Alert highlights
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton46'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button32' runat="server" CssClass='DlgCommandBtn' OnClick='DoModifyAlertNone'
                                Text='Make Default' CommandArgument='ClosePanels;ApplyDefault' />
                            <asp:Button ID='Button157' runat="server" CssClass='DlgCommandBtn' OnClick='DoModifyAlertNone'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Press button to inhibit alert coloring</label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='AlertPanel2' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Alert By Comparing To Another Cell
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton47'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose a page, if the cell is on another page</label></td>
                                <td>
                                    <asp:DropDownList ID='AlertCompareToAnotherCellPages' runat="server">
                                    </asp:DropDownList>
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Enter the Row Index of the cell to compare</label></td>
                                <td>
                                    <asp:TextBox ID='AlertCompareToAnotherCellRelativeRow' Text='0' runat="server"></asp:TextBox><asp:CheckBox
                                        ID='AlertCompareToAnotherCellRelativeRowFixed' Text='Is this Row Fixed in Position?'
                                        runat="server" />
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Enter the Column Index of the cell to compare</label></td>
                                <td>
                                    <asp:TextBox ID='AlertCompareToAnotherCellRelativeColumn' Text='-1' runat="server"></asp:TextBox><asp:CheckBox
                                        ID='AlertCompareToAnotherCellRelativeColumnFixed' Text='Is this Column Fixed in Position?'
                                        runat="server" />
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Numeric range (also known as alert threshold)</label></td>
                                <td>
                                    <asp:TextBox ID='AlertCompareToAnotherCellRelativeThreshold' Text='15' runat="server" /><br />
                                    <asp:CheckBox ID='AlertCompareToAnotherCellRelativeThresholdAsPercent' Checked="true"
                                        Text='As Percent' runat="server" />
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Color themes for Alert By Axis and Alert by Relative Cell
                                    </label>
                                </td>
                                <td>
                                    <asp:DropDownList ID='AlertToAnotherCellCSS' runat="server">
                                        <asp:ListItem Value=''>Default</asp:ListItem>
                                        <asp:ListItem Value='solid'>Solid</asp:ListItem>
                                        <asp:ListItem Value='bright'>Bright</asp:ListItem>
                                        <asp:ListItem Value='blue'>Blue theme</asp:ListItem>
                                        <asp:ListItem Value='print'>Black and White</asp:ListItem>
                                        <asp:ListItem Value='sign'>Sign</asp:ListItem>
                                        <asp:ListItem Value='arrow'>Arrow</asp:ListItem>
                                        <asp:ListItem Value='arrowbw'>Arrow in Black and White</asp:ListItem>
                                    </asp:DropDownList>
                                </td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button38' runat="server" CssClass='DlgCommandBtn' OnClick='DoModifyAlertToAnotherCell'
                                Text='Make Default' CommandArgument='ClosePanels;PageDefault' />
                            <asp:Button ID='Button160' runat="server" CssClass='DlgCommandBtn' OnClick='DoModifyAlertToAnotherCell'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Alter a cell's appearance based on a comparison with another cell, either a relative
                                cell or one that is at a fixed position. Compare value to another cell and change
                                the appearance of a cell
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='AlertPanel3' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Alert Compared to the Value of an Axis
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton48'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose a page, if the axis is on another page</label></td>
                                <td>
                                    <asp:DropDownList ID='AlertCompareToAxisPages' runat="server">
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose an axis</label></td>
                                <td>
                                    <asp:DropDownList ID='AlertCompareToAxisAxes' runat="server">
                                        <asp:ListItem Selected="true">Column</asp:ListItem>
                                        <asp:ListItem>Row</asp:ListItem>
                                        <asp:ListItem>Page</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose how you want the axis aggregated</label></td>
                                <td>
                                    <asp:DropDownList ID='AlertCompareToAxisAggregations' runat="server">
                                        <asp:ListItem Selected="true">Average</asp:ListItem>
                                        <asp:ListItem>Minimum</asp:ListItem>
                                        <asp:ListItem>Maximum</asp:ListItem>
                                        <asp:ListItem>Median</asp:ListItem>
                                        <asp:ListItem></asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Numeric range (also known as alert threshold)</label></td>
                                <td>
                                    <asp:TextBox ID='AlertCompareToAxisThreshold' runat="server" Text='15' /><br />
                                    <asp:CheckBox ID='AlertCompareToAxisThresholdAsPercent' Checked="true" Text='As Percent'
                                        runat="server" />
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Color themes for Alert By Axis and Alert by Relative Cell
                                    </label>
                                </td>
                                <td>
                                    <asp:DropDownList ID='AlertToAxisCSS' runat="server">
                                        <asp:ListItem Value=''>Default</asp:ListItem>
                                        <asp:ListItem Value='solid'>Solid</asp:ListItem>
                                        <asp:ListItem Value='bright'>Bright</asp:ListItem>
                                        <asp:ListItem Value='blue'>Blue theme</asp:ListItem>
                                        <asp:ListItem Value='print'>Black and White</asp:ListItem>
                                        <asp:ListItem Value='sign'>Sign</asp:ListItem>
                                        <asp:ListItem Value='arrow'>Arrow</asp:ListItem>
                                        <asp:ListItem Value='arrowbw'>Arrow in Black and White</asp:ListItem>
                                    </asp:DropDownList>
                                </td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button39' runat="server" CssClass='DlgCommandBtn' OnClick='DoModifyAlertToAxis'
                                Text='Make Default' CommandArgument='ClosePanels;PageDefault' />
                            <asp:Button ID='Button163' runat="server" CssClass='DlgCommandBtn' OnClick='DoModifyAlertToAxis'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Alter a cell's appearance based on a comparison with the calculated value of an
                                axis. Cell colors will be based on a comparison with an axis total
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='AlertPanel4' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Alert Using a Cell Value
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton49'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Identify the page with the numeric values that correspond to Alert Ranges</label></td>
                                <td>
                                    <asp:DropDownList ID='AlertUsingCellValuesPages' runat="server">
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Color Themes for when the values are in a range
                                    </label>
                                </td>
                                <td>
                                    <asp:DropDownList ID='CSSprefixesGroups' runat="server">
                                        <asp:ListItem Value=''>1 to 10</asp:ListItem>
                                        <asp:ListItem Value='reverse'>10 to 1</asp:ListItem>
                                        <asp:ListItem Value='temp'>1 to 10 with heat image</asp:ListItem>
                                        <asp:ListItem Value='quintile'>1 to 5</asp:ListItem>
                                        <asp:ListItem Value='quartile'>1 to 4</asp:ListItem>
                                        <asp:ListItem Value='three'>1 to 3</asp:ListItem>
                                        <asp:ListItem Value='two'>1 and 2</asp:ListItem>
                                        <asp:ListItem Value='size'>1 to 10 with size image</asp:ListItem>
                                        <asp:ListItem Value='sizequintile'>1 to 5 with size image</asp:ListItem>
                                        <asp:ListItem Value='sizequartile'>1 to 4 with size image</asp:ListItem>
                                        <asp:ListItem Value='sizethree'>1 to 3 with size image</asp:ListItem>
                                        <asp:ListItem Value='sizetwo'>1 and 2 with size image</asp:ListItem>
                                    </asp:DropDownList>
                                </td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button41' runat="server" CssClass='DlgCommandBtn' OnClick='DoModifyAlertUsingCellValues'
                                Text='Make Default' CommandArgument='ClosePanels;PageDefault' />
                            <asp:Button ID='Button166' runat="server" CssClass='DlgCommandBtn' OnClick='DoModifyAlertUsingCellValues'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Alter a cell's appearance by directly using the values of cells from another page.
                                This uses the single digit numbers from a page to choose which formatting to use.
                                These values are best obtained by using the Group operation such as Quartile or
                                custom grouping.
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel Visible="false" CssClass='L2' ID='PanelMacros' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Run a Script File
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton51'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <label class='DlgControls'>
                            Select a script file then click the OK button to run it.
                        </label>
                        <br />
                        <asp:ListBox runat="server" ID='ScriptFiles'></asp:ListBox>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button175' runat="server" CssClass='DlgCommandBtn' OnClick='DoRunScriptFile'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Select a NextAnalytics script file and run it. Script files contain a sequence of analytic
                                operations.  They're stored in the scripts directory.  They are useful to authors and 
                                IT administrators to perform routine operations without having to copy the same snippet of 
                                nextanalytics script to multiple project files. A good analogy from a programming language 
                                point of view are subroutines: They're the same thing except that they're stored in a 
                                separate file (thus making them re-usable across projects).  Parameters are passed to them 
                                via the <b>Prompt</b> mechanism.
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel Visible="false" CssClass='L2' ID='PanelRename' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Rename
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton52'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Identify the axis to search in
                                    </label>
                                </td>
                                <td>
                                    <asp:DropDownList ID='RenameLabelsAxis' runat="server">
                                        <asp:ListItem Value='Column' Selected="True">Column</asp:ListItem>
                                        <asp:ListItem Value='Row'>Row</asp:ListItem>
                                    </asp:DropDownList></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Identify the label to search for</label></td>
                                <td>
                                    <asp:TextBox ID='RenameLabelsOldColumnCaption' runat="server"></asp:TextBox></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Enter the new label</label></td>
                                <td>
                                    <asp:TextBox ID='RenameLabelsNewColumnCaption' runat="server"></asp:TextBox></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                    </label>
                                </td>
                                <td>
                                    <asp:CheckBox ID='RenameLabelsAllPages' runat="server" Text='Apply the Rename to All Pages' /></td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button178' runat="server" CssClass='DlgCommandBtn' OnClick='doChangeLabelCaption'
                                Text='OK' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Rename the selected column or row label in the current page or on all pages</label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel Visible="false" CssClass='L2' ID='PanelCellFormat' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Numeric Format
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton1'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose columns
                                    </label>
                                </td>
                                <td>
                                    <asp:ListBox runat="server" ID='PanelCellFormatListbox' SelectionMode="multiple"></asp:ListBox>
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                    </label>
                                </td>
                                <td>
                                    <asp:CheckBox runat="server" ID='PanelCellFormatInvert' Checked="False" Text='Invert Selection' /></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                    </label>
                                </td>
                                <td>
                                    <asp:CheckBox runat="server" ID='PanelCellFormatAllPages' Checked="false" Text='Change Format on All Pages with a Matching Column?' /></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Enter the Numeric Format to apply</label></td>
                                <td>
                                    <asp:TextBox  runat="server" ID='PanelCellFormatNumericFormat'></asp:TextBox></td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button runat='server' ID='Button4' CssClass='DlgCommandBtnDefault' Text='Assign Numeric Format'
                                OnClick='doAssignCellFormat' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Choose one or more columns and then assign a Numeric Format. (hint: multiple selection
                                is allowed, or you can click on columns in the crosstab) You can put N2 if you want
                                2 decimal places, N0 for no decimal places. If want your number formatted as a percent,
                                then you can put P2 or P0 (depending on the number of decimal places) but remember
                                that numbers formatted using "P" are multiplied by 100 (You can use the Arithmetic
                                operation to adjust the column values accordingly).
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel Visible="false" CssClass='L2' ID='PanelColumnFormat' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Format the column using a Cascading Style Sheet Entry
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton53'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Columns to apply this to (hint: multiple selection is allowed)</label></td>
                                <td>
                                    <asp:ListBox runat="server" ID='AssignColumnFormatColumns' SelectionMode="multiple">
                                    </asp:ListBox>
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                    </label>
                                </td>
                                <td>
                                    <asp:CheckBox runat="server" ID='InvertSelectedColumnsForFormat' Checked="False"
                                        Text='Invert Selection' /></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                    </label>
                                </td>
                                <td>
                                    <asp:CheckBox runat="server" ID='AssignColumnFormatAllPages' Checked="false" Text='Change Format on All Pages with a Matching Column?' /></td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        CSS Style to use for this column</label></td>
                                <td>
                                    <asp:TextBox  runat="server" ID='AssignColumnCSS'></asp:TextBox>
                                </td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button runat='server' ID='Button5' CssClass='DlgCommandBtn' Text='Assign CSS'
                                OnClick='doAssignColumnCSS' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Choose Column and then assign enter the name of a CSS style. (n.b. overrides alert
                                color settings)
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>

        <asp:Panel CssClass='L2' Visible="false" ID='AdminSaveAsProjectPanel' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Save As a New Project
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton67'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Existing Project Files</label></td>
                                <td>
                                    <asp:ListBox ID='AdminSaveAsProjectListBox' OnSelectedIndexChanged='DoPopulateAdminSaveProjectAs'
                                        AutoPostBack="true" runat="server"></asp:ListBox>
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        File Name</label></td>
                                <td>
                                    <asp:TextBox ID='AdminSaveAsProjectFileName' SkinID="WideTextBox" runat="server"></asp:TextBox>
                                </td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button CssClass='DlgCommandBtnDefault' ID='Button43' OnClick='DoAdminSaveAsProject'
                                runat="server" Text='OK' CommandArgument='ClosePanels'></asp:Button>
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label id='AdminSaveAsProjectFootnote' runat="server" class='DlgFootnote'>
                                Enter the name of the new project. The list of existing files is provided as a reference in case
                                you wanted to overwrite one, or to avoid overwriting one (no warning is issued!). 
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='AdminSaveAsProjectPanelForNod' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Save As a Project For High Performance Deployment
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton55'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Existing Project Files</label></td>
                                <td>
                                    <asp:ListBox ID='AdminSaveAsProjectListBoxForNod' OnSelectedIndexChanged='DoPopulateAdminSaveProjectAsForNod'
                                        AutoPostBack="true" runat="server"></asp:ListBox>
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Project File Name</label></td>
                                <td>
                                    <asp:TextBox ID='AdminSaveAsProjectFileNameForNod' SkinID="WideTextBox" runat="server"></asp:TextBox>
                                </td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button CssClass='DlgCommandBtnDefault' ID='Button1' OnClick='DoAdminSaveAsProjectForNod'
                                runat="server" Text='OK' CommandArgument='ClosePanels'></asp:Button>
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label id='Label1' runat="server" class='DlgFootnote'>
                                Enter the name of the new project. The list of existing files is provided as a reference in case
                                you wanted to overwrite one, or to avoid overwriting one (no warning is issued!). 
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>

        <asp:Panel CssClass='L2' Visible="false" ID='AdminAddPagePanel' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Save Page As New Page
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton63'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        List of Existing Page Files</label></td>
                                <td>
                                    <asp:ListBox ID='AdminAddPageFileNames' runat="server" OnSelectedIndexChanged='DoPopulateAdminAddPageFileName'
                                        AutoPostBack="true"></asp:ListBox>
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        File Name</label></td>
                                <td>
                                    <asp:TextBox ID='AdminAddPageFileName' SkinID="WideTextBox"  runat="server"></asp:TextBox><br />
                                </td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button CssClass='DlgCommandBtnDefault' ID='Button29' OnClick='DoAdminAddPage'
                                runat="server" Text='OK' CommandArgument='ClosePanels'></asp:Button>
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Enter the name of the page file. This allows you to add a page to the project</label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='AdminAddDataPanel' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Add a NextAnalytics Data File to the Project
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton62'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        List of Existing Data Files</label></td>
                                <td>
                                    <asp:ListBox ID='AddDataFileNames' runat="server" OnSelectedIndexChanged='DoPopulateAdminAddDataFileName'
                                        AutoPostBack="true"></asp:ListBox>
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        File Name</label></td>
                                <td>
                                    <asp:TextBox ID='AdminAddDataFileName' SkinID="WideTextBox"  runat="server"></asp:TextBox>
                                </td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button CssClass='DlgCommandBtnDefault' ID='Button26' OnClick='DoAdminAddData'
                                runat="server" Text='OK' CommandArgument='ClosePanels'></asp:Button>
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Enter the name of the data file. This allows you to add a data file directly to
                                the project</label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='AdminSaveProjectScriptPanel' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Save the operations you have performed interactively into the Project file<br />
                                    (Press OK to continue saving)
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton61'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <div class='DlgCommandArea'>
                            <asp:Button CssClass='DlgCommandBtnDefault' ID='Button23' OnClick='DoAdminSaveProjectScript'
                                runat="server" Text='OK' CommandArgument='ClosePanels'></asp:Button>
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Save Transactions. This saves all the commands that you have used to make changes
                                to the data from the moment you opened the project or the time of the last time
                                you saved the transactions. If ever this project is opened, then all steps are repeated,
                                even if the data itself is different (i.e. updated with more or newer records).
                            </label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='AdminSavePageExportedPanel' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Export Page - Enter a filename, choose an output format, then press OK
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton60'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <label class='DlgControls'>Existing Files in the Data Directory</label>
                        <br />
                        <asp:ListBox ID='ListofFilesInImportedDataDir' OnSelectedIndexChanged='DoPopulateAdminSavePageExportedFileName'
                            AutoPostBack="true" runat="server"></asp:ListBox>
                        <br />
                        <label class='DlgControls'>Enter a File Name to Save Data into</label><br />
                        <asp:TextBox ID='AdminSavePageExportedFileName' runat="server" SkinID='TextTextBox' ></asp:TextBox>
                        <br />
                        <label class='DlgControls'>Choose an Output Format</label>
                        <asp:RadioButtonList runat="server" ID='ExportFormats'>
                            <asp:ListItem Selected="true" Text='Data File for AddData script' Value='SavePagetoNod' />
                            <asp:ListItem Text='XML (Crosstab) for Grid Controls' Value='savepagetoxmlcrosstab' />
                            <asp:ListItem Text='CSV (Crosstab) for general use' Value='savepagetocsv' />
                            <asp:ListItem Text='CSV (Pivot) for Microsoft Reporting Services and Excel' Value='savepagetocsvpivot' />
                        </asp:RadioButtonList>
                        <br />
                        <div class='DlgCommandArea'>
                        <asp:Button CssClass='DlgCommandBtnDefault' ID='Button20' OnClick='DoAdminSavePageExported'
                                runat="server" Text='OK' CommandArgument='ClosePanels'></asp:Button>
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                This allows you to create a file of the data that you see on the currently selected page.
                                You can select an existing data file to overwrite it, or enter a new one.  
                                After you press OK, the data file will be saved in your data directory.
                                Each of the formats is formatted to a purpose, choose that one that suits your purpose.
                                <b>Using the Open Source SDK and our code samples, it is easy to write your own output 
                                file in your own specialized format!</b></label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel CssClass='L2' Visible="false" ID='PageCaptionEditPanel' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Title and Description
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton58'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Title</label></td>
                                <td>
                                    <asp:TextBox SkinID="WideTextBox" ID='PageCaptionNew' runat="server" TextMode="multiLine"
                                        Rows='2'></asp:TextBox><br />
                                </td>
                            </tr>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Description</label></td>
                                <td>
                                    <asp:TextBox SkinID="wideTextBox" ID='PageDescriptionNew' runat="server" TextMode="multiLine"
                                        Rows='5'></asp:TextBox>
                                </td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button CssClass='DlgCommandBtnDefault' ID='Button7' OnClick='DoChangeCaption'
                                runat="server" Text='OK' CommandArgument='ClosePanels'></asp:Button>
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Enter a new title and optional description</label>
                        </div>
                    </div>
                </div>
            </div>
        </asp:Panel>
        <asp:Panel Visible="false" CssClass='L2' ID='PanelDeleteTextColumn' runat="server">
            <div class='DlgFrame'>
                <div>
                    <table width='100%'>
                        <tr>
                            <td class='DlgTitleArea'>
                                <label class='DlgTitle'>
                                    Delete a Text Column
                                </label>
                            </td>
                            <td class='DlgCloseBtnArea'>
                                <asp:ImageButton CssClass='DlgCloseBtn' OnClick='closeAllDlgs' ID='ImageButton54'
                                    runat='server' ImageUrl="~/Images/close_btn_hover.png" AlternateText='Close Open Dialogs' />
                            </td>
                        </tr>
                    </table>
                </div>
                <div class='DlgInterior'>
                    <div class='DlgMainInstructionArea'>
                        <table>
                            <tr>
                                <td class='DlgControlsArea'>
                                    <label class='DlgControls'>
                                        Choose the Property</label></td>
                                <td>
                                    <asp:DropDownList runat="server" ID='SwapTextColumnWithColumnPropertyIndex3'>
                                    </asp:DropDownList></td>
                            </tr>
                        </table>
                        <div class='DlgCommandArea'>
                            <asp:Button ID='Button18' runat="server" CssClass='DlgCommandBtn' OnClick='doDeleteTextColumn'
                                Text='OK' CommandArgument='ClosePanels' />
                        </div>
                        <div class='DlgFootnoteArea'>
                            <label class='DlgFootnote'>
                                Removes a text column from this page. A useful operation to follow this would be
                                to combine similar or combine duplicates which can result in a new summarized view
                                of the data.
                            </label>
                        </div>
                    </div>
                </div>
            </div>
            <table>
            </table>
        </asp:Panel>
        
        <table width='100%'>
            <tr align='center'>
                <td align="center">
                    <asp:Label CssClass='PageCaption' ID='UnselectablePageCaption' runat="server" Visible="false"></asp:Label>
                    <br />
                    <asp:Label Visible='false' ID='PageDescription' runat="server"></asp:Label>
                </td>
            </tr>
        </table>

        <asp:Panel Visible="false" ID='Panel1' CssClass='ToolBar' runat="server" Width='95%'>
            <table width='100%'>
                <tr>
                    <td align="right">
                        <asp:TextBox ID='RowCount' runat="server" Text='20' ToolTip='count of rows to show' />
                        <label class='DlgTitle'>
                            rows starting at</label>
                        <asp:TextBox ID='RowThumb' runat="server" Text='0' ToolTip='enter a starting index or text to search for in the list of row labels' />
                        <asp:Button runat="server" ID='Button6' Text='View' />
                    </td>
                </tr>
            </table>
        </asp:Panel>
        <br />
        <table id='CurrentPageCrosstab' class="DataTable" runat="server" cellspacing="1" width='100%'>
        </table>
        <br />
        
        <asp:Panel ID='ScriptBox' runat='server' > 
        
        <asp:Label CssClass='DlgTitle' ID='Label2' runat="server" Visible="true">
        The following text is the script that's generated each time you perform an operation. These scripts can be edited, saved, and used in future operations:</asp:Label>

        <br /><asp:Button ID='SaveRunBtn' OnClick='DoSaveChangesToProjectFile'
            runat="server" Text='Save / Run' ToolTip='Save your change and run' />
        <br />
        <asp:TextBox CssClass='ProjectScript' runat="server" ID='ProjectScript' TextMode='multiLine' Rows='30' Height='75%'
            EnableViewState="false" SkinID='WideTextBox' />
        
        </asp:Panel>
        <br />
        
        <!-- the following section is convenient to search for help on topics at our web site -->
        <asp:Label CssClass='DlgTitle' ID='OfferHelp' runat="server" Visible="true">
        In the following window, Google.com gives worldwide access to examples of:</asp:Label>
        <asp:TextBox runat='server' ID='GoogleSearchWords' AutoPostBack='true' />
        <asp:Button runat="server" id='btnGoogleSearch' OnClick='DoGoogleSearch' Text='Search' /><br  />
         <iframe runat="server" id='GoogleResults' visible='false' width='800px' height='600px'></iframe>
        <br />  
         <asp:TextBox Width='800px' Height='600px' runat='server' ID='ResultAsSQL' AutoPostBack='false' />

    </form>
</body>
</html>
